How to: Copy a worksheet within a workbook.
Solution:
Select the worksheet to copy, press and hold down CTRL, and drag the sheet tab to the new location in the workbook.
1) Click the tab for the worksheet to copy. (The worksheet is selected.)
2) Press and hold down CTRL.
3) Drag the sheet tab to the new location. (A copy of the selected worksheet appears in the new location.)
